www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/khb.cpp
// khb.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "khb.h" #include "ado.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // khb dialog khb::khb(CWnd* pParent /*=NULL*/) : CDialog(khb::IDD, pParent) { //{{AFX_DATA_INIT(khb) //}}AFX_DATA_INIT } void khb::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(khb) DDX_Control(pDX, IDC_EDIT9, m_edit9); DDX_Control(pDX, IDC_EDIT8, m_edit8); DDX_Control(pDX, IDC_EDIT7, m_edit7); DDX_Control(pDX, IDC_EDIT6, m_edit6); DDX_Control(pDX, IDC_EDIT4, m_edit4); DDX_Control(pDX, IDC_EDIT3, m_edit3); DDX_Control(pDX, IDC_EDIT5, m_edit5); DDX_Control(pDX, IDC_EDIT2, m_edit2); DDX_Control(pDX, IDC_EDIT16, m_edit16); DDX_Control(pDX, IDC_EDIT15, m_edit15); DDX_Control(pDX, IDC_EDIT14, m_edit14); DDX_Control(pDX, IDC_EDIT13, m_edit13); DDX_Control(pDX, IDC_EDIT12, m_edit12); DDX_Control(pDX, IDC_EDIT11, m_edit11); DDX_Control(pDX, IDC_EDIT10, m_edit10); DDX_Control(pDX, IDC_EDIT1, m_edit1); DDX_Control(pDX, IDC_COMBO5, m_com5); DDX_Control(pDX, IDC_COMBO4, m_com4); DDX_Control(pDX, IDC_COMBO3, m_com3); DDX_Control(pDX, IDC_COMBO2, m_com2); DDX_Control(pDX, IDC_COMBO1, m_com1); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(khb, CDialog) //{{AFX_MSG_MAP(khb) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // khb message handlers BOOL khb::OnInitDialog() { CDialog::OnInitDialog(); ado load; load.Open("select * from tb_Client_sfzy",adCmdText); int rstnum=load.GetRecordCount(); int l; for(l=1;l<=rstnum;l++) { this->m_com3.AddString(load.GetFieldValue("sfzy_sfmc")); load.Move(l); } load.Open("select * from tb_Client_qyxz",adCmdText); rstnum=load.GetRecordCount(); for(l=1;l<=rstnum;l++) { this->m_com1.AddString(load.GetFieldValue("qyxz_xzmc")); load.Move(l); } load.Open("select * from tb_Client_khjb",adCmdText); rstnum=load.GetRecordCount(); for(l=1;l<=rstnum;l++) { this->m_com4.AddString(load.GetFieldValue("khjb_jbmc")); load.Move(l); } load.Open("select * from tb_Client_qylx",adCmdText); rstnum=load.GetRecordCount(); for(l=1;l<=rstnum;l++) { this->m_com2.AddString(load.GetFieldValue("qylx_lxmc")); load.Move(l); } load.Open("select * from tb_Client_qyzx",adCmdText); rstnum=load.GetRecordCount(); for(l=1;l<=rstnum;l++) { this->m_com5.AddString(load.GetFieldValue("qyzx_zxjb")); load.Move(l); } load.close(); this->m_edit3.LimitText(6); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void khb::enableall(bool b) { m_edit1.EnableWindow(b); m_edit2.EnableWindow(b); m_edit3.EnableWindow(b); m_edit4.EnableWindow(b); m_edit5.EnableWindow(b); m_edit6.EnableWindow(b); m_edit7.EnableWindow(b); m_edit8.EnableWindow(b); m_edit9.EnableWindow(b); m_edit10.EnableWindow(b); m_edit11.EnableWindow(b); m_edit12.EnableWindow(b); m_edit13.EnableWindow(b); m_edit14.EnableWindow(b); m_edit15.EnableWindow(b); m_edit16.EnableWindow(b); m_com1.EnableWindow(b); m_com2.EnableWindow(b); m_com3.EnableWindow(b); m_com4.EnableWindow(b); m_com5.EnableWindow(b); } void khb::wintotext() { m_edit1.GetWindowText(edit1); m_edit2.GetWindowText(edit2); m_edit3.GetWindowText(edit3); m_edit4.GetWindowText(edit4); m_edit5.GetWindowText(edit5); m_edit6.GetWindowText(edit6); m_edit7.GetWindowText(edit7); m_edit8.GetWindowText(edit8); m_edit9.GetWindowText(edit9); m_edit10.GetWindowText(edit10); m_edit11.GetWindowText(edit11); m_edit12.GetWindowText(edit12); m_edit13.GetWindowText(edit13); m_edit14.GetWindowText(edit14); m_edit15.GetWindowText(edit15); m_edit16.GetWindowText(edit16); m_com1.GetWindowText(com1); m_com2.GetWindowText(com2); m_com3.GetWindowText(com3); m_com4.GetWindowText(com4); m_com5.GetWindowText(com5); } void khb::texttowin() { m_edit1.SetWindowText(edit1); m_edit2.SetWindowText(edit2); m_edit3.SetWindowText(edit3); m_edit4.SetWindowText(edit4); m_edit5.SetWindowText(edit5); m_edit6.SetWindowText(edit6); m_edit7.SetWindowText(edit7); m_edit8.SetWindowText(edit8); m_edit9.SetWindowText(edit9); m_edit10.SetWindowText(edit10); m_edit11.SetWindowText(edit11); m_edit12.SetWindowText(edit12); m_edit13.SetWindowText(edit13); m_edit14.SetWindowText(edit14); m_edit15.SetWindowText(edit15); m_edit16.SetWindowText(edit16); m_com1.SetWindowText(com1); m_com2.SetWindowText(com2); m_com3.SetWindowText(com3); m_com4.SetWindowText(com4); m_com5.SetWindowText(com5); } void khb::clearall() { m_edit1.SetWindowText(""); m_edit2.SetWindowText(""); m_edit3.SetWindowText(""); m_edit4.SetWindowText(""); m_edit5.SetWindowText(""); m_edit6.SetWindowText(""); m_edit7.SetWindowText(""); m_edit8.SetWindowText(""); m_edit9.SetWindowText(""); m_edit10.SetWindowText(""); m_edit11.SetWindowText(""); m_edit12.SetWindowText(""); m_edit13.SetWindowText(""); m_edit14.SetWindowText(""); m_edit15.SetWindowText(""); m_edit16.SetWindowText(""); m_com1.SetWindowText(""); m_com2.SetWindowText(""); m_com3.SetWindowText(""); m_com4.SetWindowText(""); m_com5.SetWindowText(""); } BOOL khb::PreTranslateMessage(MSG* pMsg) { // TODO: Add your specialized code here and/or call the base class if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13) pMsg->wParam=9; return CDialog::PreTranslateMessage(pMsg); }